Tabela JobTime

Definicja tabeli JobTime

Name

JobTime

Code

JobTime

Comment

 


Lista kolumn tabeli JobTime

Name

Code

JobTimeID

JobTimeID

WorkDuration

WorkDuration

HolidayDuration

HolidayDuration

Active

Active


Kolumna JobTimeID tabeli JobTime

Definicja kolumny JobTimeID tabeli JobTime

Name

JobTimeID

Code

JobTimeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna WorkDuration tabeli JobTime

Definicja kolumny WorkDuration tabeli JobTime

Name

WorkDuration

Code

WorkDuration

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna HolidayDuration tabeli JobTime

Definicja kolumny HolidayDuration tabeli JobTime

Name

HolidayDuration

Code

HolidayDuration

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli JobTime

Definicja kolumny Active tabeli JobTime

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli JobTime

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli JobTime

Definicja klucza Identifier_1 tabeli JobTime

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment